<html>
<head>
<meta http-equiv="Content-Type"content="text/html; charset=UTF-8" />
<title>社团信息显示</title>
</head>
<body>
<center>《<?php
include("db_conn.php");

$ShowStudent_sql = "SELECT * FROM Soci s,Department d, Mana m WHERE s.DepartNo=d.DepartNo and s.ManaNo=m.ManaNo;";
$ShowStudentResult = mysql_query($ShowStudent_sql);
$number=mysql_num_rows($ShowStudentResult);
srand((double)microtime()*1000000);
$num=rand(0,$number-1);
mysql_data_seek($ShowStudentResult,$num);
$row = mysql_fetch_array($ShowStudentResult);
echo "<b><font color=red>".$row['SociName']."</font></b>";
?>》信息列表</center>
<table  width="400" border="1" align="center">
    <tr align="center">
        <td width="160">
            <?php
            echo "<img src='../uploadpics/".$row['SociNo'].".jpg' width='160' height='190'>";
            ?>
        </td>
        <td>
            <table width="340" border="1" align="center">
                <tr>
                    <td width="100" bgcolor="#0066CC" align='right'><font color="#FFFFFF"><b>编号</b></font></td>
                    <?php echo "<td>".$row['SociNo']."</td>"; ?>
                </tr>
                <tr>
                    <td width="100" bgcolor="#0066CC" align='right'><font color="#FFFFFF"><b>类别</b></font></td>
                    <?php echo "<td>".$row['Kind']."</td>"; ?>
                </tr>
                <tr>
                    <td width="100" bgcolor="#0066CC" align='right'><font color="#FFFFFF"><b>级别</b></font></td>
                    <?php echo "<td>".$row['Level']."</td>"; ?>
                </tr>
                <tr>
                    <td width="100" bgcolor="#0066CC" align='right'><font color="#FFFFFF"><b>社长姓名</b></font></td>
                    <?php echo "<td>".$row['ManaName']."</td>"; ?>
                </tr>
                <!-- <tr>
                    <td width="100" bgcolor="#0066CC" align='right'><font color="#FFFFFF"><b>指导老师</b></font></td>
                    <?php echo "<td>".$row['Teacher']."</td>"; ?>
                </tr> -->
                <tr>
                    <td width="100" bgcolor="#0066CC" align='right'><font color="#FFFFFF"><b>需求人数</b></font></td>
                    <?php echo "<td>".$row['LimitNum']."</td>"; ?>
                </tr>
                <tr>
                    <td width="100" bgcolor="#0066CC" align='right'><font color="#FFFFFF"><b>所属院系</b></font></td>
                    <?php echo "<td>".$row['DepartName']."</td>"; ?>
                </tr>
            </table>
        </td>
    </tr>
</table>
</center>
</body>
</html>
